Tabela TumourCardMonoTherapy

Definicja tabeli TumourCardMonoTherapy

Name

TumourCardMonoTherapy

Code

TumourCardMonoTherapy

Comment

Leczenie nieskojarzone (KZNZ pole 38)


Lista kolumn tabeli TumourCardMonoTherapy

Name

Code

TumourCardMonoTherapyID

TumourCardMonoTherapyID

PatientTumourCardID

PatientTumourCardID

TumourCareType

TumourCareType

OtherCareTypeName

OtherCareTypeName

StartDT

StartDT


Kolumna TumourCardMonoTherapyID tabeli TumourCardMonoTherapy

Definicja kolumny TumourCardMonoTherapyID tabeli TumourCardMonoTherapy

Name

TumourCardMonoTherapyID

Code

TumourCardMonoTherapyID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID leczenia nieskojarzonego


Kolumna PatientTumourCardID tabeli TumourCardMonoTherapy

Definicja kolumny PatientTumourCardID tabeli TumourCardMonoTherapy

Name

PatientTumourCardID

Code

PatientTumourCardID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

karta nowotworu


Kolumna TumourCareType tabeli TumourCardMonoTherapy

Definicja kolumny TumourCareType tabeli TumourCardMonoTherapy

Name

TumourCareType

Code

TumourCareType

Data Type

VARCHAR2(2)

Mandatory

No

Comment

Rodzaj leczenia wedlug slownika DictionaryuValue z mozliwymi wartosciami:
1 – chirurgia
2 – radioterapia
3 – chemioterapia
4 – hormonoterapia
5 – immunoterapia
6 – terapia celowana
7 – przeszczep
8 – inne
W kolumnie zapisywany kod.


Kolumna OtherCareTypeName tabeli TumourCardMonoTherapy

Definicja kolumny OtherCareTypeName tabeli TumourCardMonoTherapy

Name

OtherCareTypeName

Code

OtherCareTypeName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

nazwa innego rodzaju leczenia


Kolumna StartDT tabeli TumourCardMonoTherapy

Definicja kolumny StartDT tabeli TumourCardMonoTherapy

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data rozpoczecia leczenia


Lista kluczy tabeli TumourCardMonoTherapy

Name

Code

Primary

PK_LTumourCardCare

PK_LTumourCardCare

X


Klucz PK_LTumourCardCare tabeli TumourCardMonoTherapy

Definicja klucza PK_LTumourCardCare tabeli TumourCardMonoTherapy

Name

PK_LTumourCardCare

Code

PK_LTumourCardCare

Primary

Yes

Comment